﻿

CREATE VIEW [dbo].[fares_viewUnitati]
AS
SELECT     dbo.Unitati.Denumire, dbo.Unitati.CUI, dbo.Unitati.AtributFiscal, dbo.Unitati.Adresa, dbo.Unitati.IBAN, dbo.Judete.Nume, dbo.Banci.Denumire AS DenumireBanca, 
                      dbo.Unitati.Telefon, dbo.Unitati.Fax, dbo.Unitati.Reprezentant, dbo.Unitati.Email, dbo.Unitati.JudRegComert, dbo.Unitati.NrRegComert, dbo.Unitati.AnRegComert, 
                      dbo.Unitati.CodUnitate, dbo.Unitati.CapitalSocial
FROM         dbo.Unitati LEFT OUTER JOIN
                      dbo.Judete ON dbo.Unitati.IDJudet = dbo.Judete.IDJudet LEFT OUTER JOIN
                      dbo.Banci ON dbo.Unitati.IDBanca = dbo.Banci.IdBanca